ETL Developer

  • location: Charlotte, NC
  • type: Contract
  • salary: $55 - $60 per hour
easy apply

job description

ETL Developer

job summary:
The Full Stack Developer will be primarily working with the Commercial Operations team to maintain and develop data integration solutions across our client's business area. The candidate will need to understand business and technical requirements and translate this into data integration designs and deliverables. The solutions must align with client ETL standards and guidelines. The data integration solutions will be based on Informatica with MS SQL data warehouses/database. The position will be a key component on the integration Gas Supply product replacement durable team and must have a working strong knowledge of the Agile framework and methodologies (SCRUM, Kanban). Knowledge of PowerShell and CA Workforce Automation is a plus.

 
location: Charlotte, North Carolina
job type: Contract
salary: $55 - 60 per hour
work hours: 9 to 5
education: Bachelors
 
responsibilities:
- Design and Develop ETL programs primarily using Informatica PowerCenter, PL/SQL and T-SQL,

- Extract, transform & load into relational model structures of transactional databases

- Performance improvement & tuning of Informatica mappings, SQL, T-SQL & PL/SQL scripts

- Technical reviews, Data validation & end to end testing of ETL Objects, Source data analysis and data profiling.

- Create necessary documentation

- Update the project documentation (Change Requests and JIRA's) on the confluence

- Upload the code to version control tool

- Perform Unit Testing of ETL Programs and support QA on End-to-End testing

- Work with deployment team in the code migration across environments

- Triage Production issues and work on code fixes

- Willing to learn new tools and technologies and to help teammates deliver sprint commitments

 
qualifications:
Incumbent should have strong support experience and be able to handle daily issues with different applications. We are looking for someone who enjoys troubleshooting issues and implementing solutions. Also have the ability to mentor others, lead small projects and provide troubleshooting support. Analyzes and classifies complex change request and identifies and documents possible enhancements. Participates in developing application scope and objectives and preparing functional and/or technical specifications. Develops relationships with the business to better understand business requirements. Demonstrate knowledge of both Agile and Waterfall methodologies. Experience working in an Agile environment with Jira or other agile work management tools.

Would need to be able work independently on data task with minimal amount of supervision. Ability to migrate applications from development to testing then production.

Strong problem-solving and follow-up skills; must be proactive and take initiative. Strong business acumen, excellent debugging and problem-solving skills, ability to support existing systems, and excellent communication skills both written and verbal.

Requires BA/BS degree or technical institute training; 5+ years' experience on one platform, multi-database, multi-language or multi-business application, or any combination of education and experience, which would provide an equivalent background.

Experience with Informatica is required.

Experience with PL/SQL and T-SQL is required.

Experience with ASP.Net MVC, Web services, Web API is an asset.

Experience working and developing in cloud services such as Azure is an asset.

Experience working in Tomcat Apache is an asset.

Experience working with

Experience with Silverlight is an asset.

Experience with Bit-Bucket is an asset.

Experience with GIT is an asset.

 
skills: Incumbent should have strong support experience and be able to handle daily issues with different applications. We are looking for someone who enjoys troubleshooting issues and implementing solutions. Also have the ability to mentor others, lead small projects and provide troubleshooting support. Analyzes and classifies complex change request and identifies and documents possible enhancements. Participates in developing application scope and objectives and preparing functional and/or technical specifications. Develops relationships with the business to better understand business requirements. Demonstrate knowledge of both Agile and Waterfall methodologies. Experience working in an Agile environment with Jira or other agile work management tools.

Would need to be able work independently on data task with minimal amount of supervision. Ability to migrate applications from development to testing then production.

Strong problem-solving and follow-up skills; must be proactive and take initiative. Strong business acumen, excellent debugging and problem-solving skills, ability to support existing systems, and excellent communication skills both written and verbal.

Requires BA/BS degree or technical institute training; 5+ years' experience on one platform, multi-database, multi-language or multi-business application, or any combination of education and experience, which would provide an equivalent background.

Experience with Informatica is required.

Experience with PL/SQL and T-SQL is required.

Experience with ASP.Net MVC, Web services, Web API is an asset.

Experience working and developing in cloud services such as Azure is an asset.

Experience working in Tomcat Apache is an asset.

Experience working with

Experience with Silverlight is an asset.

Experience with Bit-Bucket is an asset.

Experience with GIT is an asset.


Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

easy apply

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs

    AI Developer

  • location: Charlotte, NC
  • job type: Contract
  • salary: $50 - $55 per hour
  • date posted: 9/6/2018