Job Description

[ n Your Job The Software Engineer will be a part of a global team creating new solutions as well as improving existing solutions for Koch Industries. Koch Industries is a privately held global organization with over 120,000 employees around the world, with subsidiaries involved in manufacturing, trading, and investments. Koch Technology Center (KTC) is being developed in India to extend its IT operations, as well as act as a hub for innovation in the IT function. As KTC rapidly scales up its operations in India, itu2019s employees will get opportunities to carve out a career path for themselves within the organization. This role will have the opportunity to join on the ground floor and will play a critical part in helping build out the Koch Technology Center (KTC) over the next several years. Working closely with global colleagues would provide significant global exposure to the employees. Software Engineer will report to the Fusion Data Migration Lead and will be responsible for creating valuable solutions for Molex. Software Engineer shall be responsible for providing an end-to-end implementation of Informatica PowerCenter and Data Quality solutions based upon business requirements, data mappings, and data models. The Informatica Software Engineer will build data mappings, data profile reports, and data transformations using: Informatica PowerCenter, Informatica Data Quality (IDQ), Snowflake and Oracle SQL Developer. They will use both IDQ and SQL to extract, profile, and report upon existing data in SAP, other databases such as SQL server, and flat file extracts. They will build IDQ and SQL programs to verify the results of Informatica Mappings built by other development teams. They will also build ETLu2019s using serverless architecture tools like AWS Glue, Lambda and other AWS Services. Must be able to work until 10am CST when required for meetings or deadlines. What You Will Do Design and code advanced SQL code to be used in PowerCenter transformations. Design and code PowerCenter mappings to transform data or measure data quality. Creating and reviewing data profiling reports written in SQL. Build complex database and file connections in Snowflake, Oracle, SQL server, .csv files, to load and test business data. Implementing complex mapping transformations reading from SAP tables related to PLM (Product Life Cycle Management). Building ETL using AWS services like Glue, Athena, S3, CloudWatch and Lambda. Working in an Agile team using either SCRUM or Kanban methodologies Creating custom data staging tables in Snowflake and Oracle using DDL Building data-centric business rules and ETL in Informatica and SQL. Who You Are (Basic Qualifications) Bacheloru2019s/Masteru2019s degree in Computer Science/Information Technology or a related field Overall experience could range between 3 to 6 years. 2+ years of experience in AWS with attention/hands on services like S3, Glue, Lambda, Athena. Strong data analysis skills, with an attention to detail. Ability to code in SQL using development tools like Snowflake & Oracle SQL developer. Unix development & shell scripting skills along with Python/PySpark. 3+ years of Informatica PowerCenter and/or Informatica IDQ experience 3+ years of SQL development experience using tools like Snowflake, Oracle SQL Developer, or Microsoft SQL Developer or Toad. What Will Put You Ahead Bacheloru2019s/Masteru2019s degree in Computer Science/Information Technology or a related field. Overall experience could range between 4 to 8 years. Unix development & shell scripting skills along with Python/PySpark. Ability to code in SQL using development tools like Snowflake & Oracle SQL developer. Strong data analysis skills, with an attention to detail. 2+ years of experience in AWS with attention/hands on services like S3, Glue, Lambda, Athena. 3+ years of Informatica PowerCenter and/or Informatica IDQ experience 3+ years of SQL development experience using tools like Snowflake, Oracle SQL Developer, or Microsoft SQL Developer or Toad. Daily work schedule will overlap a minimum of 2 hours with US CST time zone (8 AM-11 AM CST) At Koch companies, we are entrepreneurs. This means we openly challenge the status quo, find new ways to create value and get rewarded for our individual contributions. Any compensation range provided for a role is an estimate determined by available market data. The actual amount may be higher or lower than the range provided considering each candidateu2019s knowledge, skills, abilities, and geographic location. If you have questions, please speak to your recruiter about the flexibility and detail of our compensation philosophy. Who We Are As a Koch company, Koch Global Services (KGS) creates solutions spanning technology, human resources, finance, project management and anything else our businesses need. With locations in India, Mexico, Poland and the United States, our employees have the opportunity to make a global impact xa0 xa0 \' Koch is proud to be an equal opportunity workplace\' n ]

foundit