ETL Developer - Datastage (W2)
Data Engineer (Datastage)
Location : Remote EST hours
6 months contract to hire ( need to have GC/USC. Client does not sponsor visa)
Key : DataStage, Python and COGNOS.
DataStage ETL developer that Python experience and has done some COGNOS reports.
• Develop reliable, reusable, automated and streamlined ETL code
• Analyze and organize raw data from multiple sources to produce requested or required data elements
• Design table structures and ETL to build performant data solutions that are scalable in a fast growing data ecosystem
• Create reconciliation procedures and data checks to ensure data quality
• Build in automated audit, balancing and controls
• Provide production support, including on-call rotation and technical assistance to end-user and IT staff
Skills
• Proven experience in designing and implementing ETL processes (tools: IBM's DataStage, SQL, SAS, Python)
• Proven experience distilling business requirements into data warehouse design artifacts such as a Facts Qualifier Matrix (FQM), source to target maps and star/snowflake schema data models
• 5+ years experience with SQL, Data Modeling and Dimensional Modeling
• Knowledge of developing BI dashboards (preferred tools: IBM's Cognos, Microsoft's Power BI); creating data quality scorecards and data lineage
• Experience with agile teams
• Mentor development team members in design and development of BI solutions
