Please reply to ,
Position: SSIS ETL Developer
Location: Ontario, CA
Duration: 6+ Months
Rate: $48 CTC
Mode of Interview: Phone + Onsite (No Skype)
Locals are HIGHLY preferred for this opportunity, and an onsite interview is absolutely required.
No h1B, OPT and Need Only Local or Near By Candidate because interview Mode Face 2 Face.
Experience with Data mapping, data quality, data cleansing, data governance, data analysis, data profiling, database testing or data management.
What they will be working on: The ETL developer is responsible for the implementation, support, and administration activities required to maintain the operational integrity of their ETL processes. They will be designing and developing ETL solutions using SSIS and other tools to transfer data between applications and other sources and consumers of data. This person will also be responsible for unit testing and validation, problem assessment and resolution, current ETL process enhancement, and documentation for existing and new ETL packages including workflow mapping while maintaining strict adherence to company data governance requirements.
Responsibilities include designing and developing ETL solutions using Microsoft's SQL Server Integration Services (SSIS) and other tools to transfer data between applications and other sources and consumers of data. Additional responsibilities include unit testing and validation, problem assessment and resolution, current ETL process enhancement, and documentation for existing and new ETL packages including workflow mapping while maintaining strict adherence to company data governance requirements.
Additionally, you may be assigned to participate on project teams providing expertise as required to deliver on the project objectives.
•Along with other key personnel, ensure the overall data integrity and conformity of the information gathered. Manage data quality tasks through the ETL processes.
•Work with DBA Group, Development Teams, and Business Analyst to identify and understand source data systems, as well as provide input for enhancements for standardization and consistency across the Enterprise (Transactional systems, Data Warehouse, etc.)
•Map Import/Export Files to source system data. Map source data to data warehouse models.
•Develop and test extraction, transformation, and load (ETL) processes.
•Develop and maintain ETL scripts and workflows, SQL queries, VB/C++ script components, schedules, etc. using SVN for version control.
•Understand and maintain appropriate data release documentation and approvals according to company policies and procedures
•Define and capture metadata and rules associated with ETL processes.
•Develop processes to identify and analyze data quality issues and recommendations to resolve.
•Document, including diagrams, the architecture and components of the Reporting data warehouse.
•Modify existing ETL processes to improve performance and adapt to changing requirements.
•Use SQL Server query techniques and available tools, against the transaction system and the reporting data warehouse, to identify and analyze data quality issues.
•Perform daily review of production data processes to ensure successful completion
•Provide expertise in the review and correction of data integrity and / or reporting issues
•Review, understand, and provide feedback on functional requirements from a database perspective
•Provide data analysis/troubleshooting/creation support to QA, Developers, Support and others allowing them to complete their assignments.
•Develop, test, and debug new functionality, and maintain/enhance existing functionality in using SQL, stored procedures and API's
•Will ensure ETL process and project documentation is updated and current for all release cycles.
•Performs performance tuning of queries and stored procedures.
•Has 6 years+ experience in support of Microsoft SQL Server databases in a transactional environment
•Is an expert in the creation of SQL stored procedures
•Full understanding of Extract Transform Load (ETL) concepts and technologies
•Full understanding of the processes of data quality, data cleansing, and data governance
3 years of job-related experience with data analysis, data profiling, data quality, database testing or data management.
Must be able to clearly communicate in writing and orally to both technical and non-technical teams and all levels of management.
Able to multi-task on several projects
•Bachelor degree in engineering, business or technology
•Data related certifications (CDMP, MS SQL MCM, MCITP, MCA)
•Experience in a highly regulated and structured work environment
•Healthcare experience is a plus
1 Point System LLC
Unit 103, 206 N College St, Pineville, North Carolina, 28134
Hangout: email@example.com LinkedIn: https://www.linkedin.com/in/vineet-mishra-9a232112a/
For Job Updates please add: 1 Point System-Jobs/Hotlist
An E-Verified company | An Equal Opportunity Employer
Note: 1 Point System LLC works with Direct Clients and Preferred Vendors Nationwide.
Your confirmation would means that you understand the level of 1 Point System LLC association for the mentioned project and will not approach 1 Point System LLC Client directly
You received this message because you are subscribed to the Google Groups " c2c jobs usa" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firstname.lastname@example.org.
To post to this group, send email to email@example.com.
Visit this group at https://groups.google.com/group/c2cjobsusa.
For more options, visit https://groups.google.com/d/optout.