DataStage ETL Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Job Alert
You will be updated with latest job alerts via email
Job Description
**We need A senior (10 years) DataStage ETL developer with 10 years of experience designing developing testing and implementing Extract Transform and Load (ELT/ETL) solutions using DataStage as well as experience developing and implementing data integration data lake and data warehouse solutions in an onpremise and cloud environments. ****CANDIDATES NEED TO HAVE BANKING OR FINANCIAL SERVICES EXPERIENCE.
Interview Process: Video
Location: New York City or Troy MI or Clevland OH No Relocation Candidates must be onsite day one and go into the office three times a week.
Job Description:
The Sr. DataStage Developer is responsible in understanding and supporting the businesses through the design development and execution of Extract Transform and Load (ELT/ETL) data integration and data analytics processes across the enterprise. He/She will stay on top of tech trends experiment with and learn new technologies contribute to the growth of data organization participate in internal & external technology communities and mentor other members of the team. Provide technical leadership at every stage of the data engineering lifecycle from designing data platforms data pipelines data stores and gathering importing wrangling querying and analyzing data. The Sr data engineer will work closely with various customers including their immediate project teams business domain experts and other technical staff members. Work daily within a project team environment taking direction from project management and technical leaders. Responsible for design development administration support and maintenance of the Snowflake Platform and Oracle Platform. Participates in the full systems life cycle and cloud data lake/data warehouse design and build including recommendation of code development integration with data marketplace or reuse and buy versus build solutions.
Job Responsibilities:
Job Requirements:
- 10 years of experience designing developing testing and implementing Extract Transform and Load (ELT/ETL) solutions using DataStage.
- 10 years of experience developing and implementing data integration data lake and data warehouse solutions in an onpremise and cloud environment.
- 10 years of experience with various Software Development Life Cycle methods such as Agile SCRUM Waterfall etc.
- 3year experience in 100 TB data environment.
- Proven experience developing and maintaining data pipelines and ETL jobs using IBM DataStage Informatica Matillion FiveTran Talend or Dbt.
- Knowledge of AWS cloud services such as S3 EMR Lambda Glue Sage Maker Redshift & Athena and/or Snowflake.
- Experienced in data modelling for selfservice business intelligence advanced analytics and user application.
- Ability to communicate complex technical concepts by adjusting messaging to the audience: business partners IT peers external stakeholders etc.
- Proven ability to design and build technical solutions using applicable technologies; ability to demonstrate exceptional data engineering skills.
- Ability to prioritize work by dividing time attention and effort between current project workload and ongoing day to day activities.
- Demonstrates strength in adapting to change in processes procedures and priorities.
- Proven ability to establish a high level of trust and confidence in both the business and IT communities.
- Strong teamwork and interpersonal skills at all management levels.
- Proven ability to manage to a project budget.
- Experience applying agile practices to solution delivery.
- Must be teamoriented and have excellent oral and written communication skills.
- Strong analytic and problemsolving skills.
- Good organizational and timemanagement skills.
- Experience in Strategic Thinking and Solutioning.
- Must be a selfstarter to understand existing bottlenecks and come up with innovative solution.
- Demonstrated ability to work with key stakeholders outside the project to understand requirements/resolve issues.
- Experience with data model design writing complex SQL queries etc. and should have a good understanding of BI/DWH principles.
- Expertise in Relational Database Management System Data Mart and Data Warehouse design.
- Expertlevel SQL development skills in a multitier environment.
- Expertise in flat file formats XML within PL/SQL and file format conversion.
- Strong understanding of SDLC and Agile Methodologies.
- Strong understanding of model driven development.
- Strong understanding of ETL best practices.
- Proven strength in interpreting customer business needs and translating them into application and operational requirements.
- Strong problemsolving skills and analytic skills with proven strength in applying root cause analysis.
Employment Type
Full Time
