Apply Now    

Software Engineer-(ETL"Ab Initio",Talend & Big Data )

Req #: 170076569
Location: Lewisville, TX, US
Job Category: Technology
Potential Referral Amount: US Dollar (USD)
  • The Software Engineer is responsible for working on an Agile development team to determine the changes needed to the data model , databases along with the necessary ETL coding and implementation for regulatory reporting. Responsible for design and development of various ETL processing using Oracle PL/SQL, Ab Initio and Unix Shell scripting. Responsible for writing complex SQLs for data analysis and data profiling. Knowledge of database architecture/practices is essential. Experience with Business Intelligence (BI) tools such as Tableau and Bigdata querying & ETL tools is preferred. This is an individual contributor that may have team lead responsibilities for 1-4 people.

     Specific responsibilities/skills:
    • Advanced experience & demonstrated proficiency in all aspects of Ab Initio tool set to create graphs, using performance improvement components, parallel processing, graph tuning, single and multi-file processing, metadata processing using EME etc.
    • Significant experience & proficiency in all aspects of Oracle PL/SQL programming and data analysis, including Cursors, Ref-cursors, Oracle procedures/packages, Collections, Partitioned Tables, Triggers, Table Indexing. Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, various Oracle Objects, etc.
    • Strong experience on database design, best architecture practices, normalization and dimensional modeling etc.
    • Experience working on Agile methodologies as developer.
    • Preferred experience with Bigdata technologies and tools such as Apache Hadoop/Cloudera/MapR/HortonWorks, HDFS, MapReduce, Spark, Big Data querying tools (such as Pig, Hive, Impala), NoSQL databases (such as HBase, Cassandra, MongoDB)
    • Preferred experience with Business Intelligence tools such as Tableau
    • Fundamentals and Solid facilitation skills to gather the necessary (functional & technical) information to document and/or develop a strategic/tactical plan. Able to properly document (functional & technical) source to target mappings, process flows, data flows, technical specification and unit test document
    • Work independently in the design, development, testing, implementation and maintenance of systems of moderate size/complexity with a fast turn-around
    • Perform extensive business process analysis including data analysis and GAP analysis
    • Apply innovation, creativity, and improvement to the development process
    • Problem-solving, keep abreast of new technologies
    • Serve as a process expert for a defined functional area, which includes: 
      • Managing key data sources & inputs
      • Planning and ensuring implementation of end state automation activities
      • Providing guidance for the design, development, and implementation of automated processes 
Required Qualifications:
  • Bachelors’ degree in Computer Science, Engineering, Information Technology or related area
  • 5+ years’ experience in Distributed Multi-tier Application Development, Database Design, Data processing, Data Warehouse and Support mainly with Oracle technology on different platforms
  • Candidates must have advanced experience with Oracle SQL, PL/SQL, Data Analysis and Performance Tuning. Hands on experience of Tools like TOAD, SQL Developer, and SQL Loader.
  • Advanced hands on experience at Ab Initio ETL design and development including EME and BRE
  • Experience with BigData fundamentals, querying and ETL technologies
  • Working experience as Agile developer and good understanding of SDLC methodologies/guidelines
  • Experience at developing complex UNIX shell scripts
  • Experience with Subversion or similar source code versioning tools and coding standards
  • Experience with scheduling tool such as Control-M or similar tools
Preferred Qualifications:
  • 2-3 years of Mortgage/Banking/finance analytical support experience preferred, but not mandatory.
  • Experience with Talend ETL tool  
  • Experience with Tableau or Cognos BI tools
Apply Now    

Join our Talent Community

Not ready to apply? Leave your information with us and we will keep you up to date with new career opportunities.

Things to note

Sign in to our application system to continue your job search or update your profile.

Current employees sign in here. Contractors sign in here.

Any information you provide is confidential and will only be viewed by our recruiters in an effort to fill open positions. In addition, the information you provide is subject to our privacy policy practices.

Please note that J.P. Morgan will not accept unsolicited approaches or speculative CVs, nor will J.P. Morgan be responsible for any related fees, from Third Party Firms who are not preferred suppliers.

The firm invites all interested and qualified candidates to apply for employment opportunities.

Need disability related assistance?

If you are a US or Canadian applicant with a disability who is unable to use our online tools to search and apply for jobs, please click here.

Important links

Click here to view the "EEO is the Law" poster.

Click here to view the "EEO is the Law" supplemental poster.

Click here to view our U.S. Pay Transparency Policy.

JPMorgan Chase is an equal opportunity and affirmative action employer Disability/Veteran.