Conversion ETL Developer (Senior)

  • J29 Inc,
  • Linthicum Heights, MD
company banner
J29 Inc
Cloudera, PostgreSQL, shell scripting, Linux, BDM, Power Exchange, Informatica, ETL, performance tuning, File base conversion
Full Time
Depends on Experience
Work from home not available Travel not required

Job Description

Position: Conversion ETL Developer (Senior)

Description of specific duties in a typical workday for this position:

  • Work with ETL developers, business analyst, DBAs, system administrators, data modeling teams for ETL build and design.
  • Translate business requirements into technical requirements.
  • Understanding of data quality methodologies and data governance to ensure standardization of data.
  • Contribute to the requirements elicitation process, create application architecture documents.
  • Design develop and test ETL mappings, mapplets, workflows using Informatica BDM (10.2.x) or Talend (5.x or 6.x) or Stream sets (3.6 and above).
  • Performance tuning of end-to-end ETL integration processes.
  • Determine optimal approach for obtaining data from diverse source systems.
  • Key contributor to initiatives that require technical expertise.
  • Work closely with the team responsible for maintaining the data model, including data dictionary/metadata registry.
  • Interface with business stakeholders to understand requirements and offer solutions.

Position Requirements:

  • At least six (6) years of experience in ETL tools and with focus in legacy conversion and performance tuning of conversion run.
  • Experience with File base conversion.
  • Experience with one of the ETL tools Informatica Big Data Manager (BDM, Power Exchange (CDC), Data Quality (BDQ)) or Talend or StreamSets in creation of complex parallel loads and dependency creation using workflows.
  • Strong exposure working with web service sources/Targets, XML Sources and Restful API s.
  • At least three (3) years of experience with Linux / shell scripting complementary with Informatica.
  • At least three (3) years of experience in performance tuning.
  • Possess expertise in project migration and release coordination activities.
  • Strong exposure working with relation databases DB2, Oracle & SQL Server including complex SQL constructs and DDL generation.
  • Experience in managing and deploying applications in AWS is preferred.
  • Strong knowledge of relational databases and extensive experience with SQL scripting / stored procedures in PostgreSQL.
  • Experience with data modeling and data mapping design.
  • Experience in SQL and conversion of SQL stored procedures into Informatica.
  • At least two (2) years of experience in data lake development including Cloudera is preferred.
  • Strong scripting skills with some experience in software engineering.

Company Information

J29 is an Economically Disadvantaged Woman Owned Small Business (EDWOSB) and member of the Maryland Small Business Reserve (SBR) Program headquartered in Millersville, Maryland. Our clients include those primarily at the federal, state, and local government levels, as well as a variance of commercial entities. From customized technical solutions, to services, J29 also offers a diverse array of human and agile services, to meet the modern day demands of every business cycle. J29 is a people centric company and this philosophy begins with our employees. We believe that by putting people first we attract the best and brightest within our industries while creating a culture of innovation, creativity and integrity. Since employee satisfaction is directly proportional to customer satisfaction, we take great pride in our customers experience with J29. Since we consciously choose to prioritize our employees, our employees choose to invest in and prioritize our customers.
Dice Id : 91095883
Position Id : 6140118

Similar Positions at J29 Inc

SQL Developer / Analyst
  • Linthicum Heights, MD
  • 1 week ago