Search Jobs
PDS Inc, LLC
http://www.pdsinc.com
http://www.pdsinc.com
true
ETL Developer/Data Engineer
Posted: 08/18/2023
2023-08-18
2024-01-04
Employment Type:
Contract
Job Category: Data Engineering
Job Number: 22708
Workplace Type: Remote
Job Description
ETL Developer/Data Engineer
Compensation:
Their role is to develop, enhance and support data pipelines using Informatica Power center, AWS and Snowflake.
PROJECT INFORMATION:
Contractor will be working on the Modernizers team, EAM BI team. Their role is to develop, enhance and support data pipelines using Informatica Power center, AWS and Snowflake.
PRINCIPAL RESPONSIBILITIES:
• Designs and develops code and data pipelines to ingest from relational databases (Oracle, SQL Server, DB2, Aurora), file shares, and web services.
• Design and build Informatica Power Center mappings and workflows
• Streaming ingestion with Kinesis Streams, Kinesis Firehose, Kinesis Analytics and Kafka (MSK)
• Build Data Lake on AWS S3 with optimal performance considerations by partitioning and compressing data.
• Data Engineering and Analytics using AWS Glue, Informatica, EMR, Spark, Athena, Python.
• Data modeling and building Data Warehouse using Snowflake.
• Designs and develops code and data pipelines to ingest relational databases, file shares, and web services.
• Designs JavaScript modules and REST APIs utilizing MarkLogic to support complex searches.
• Develops MarkLogic integrations with existing enterprise platforms.
• Participates in requirements definition, system architecture design, and data architecture design.
• Participates in all aspects of the software life cycle using Agile development methodologies.
• Build and design Informatica Power Center mappings and workflows
MINIMUM QUALIFICATIONS:
• Bachelor’s degree in Computer Science, Computer Information Systems, Engineering, Statistics or closely related field (willing to accept foreign education equivalent) (required).
• Experience in AWS services for data and analytics (required).
• 5 years of experience in Data Ingestion, Data Extraction, and Data Integration (required).
PREFERRED QUALIFICATIONS:
• 5+ years of experience in Enterprise Information Solution Architecture, Design, and development required.
• 5+ years of experience with integration architectures such as SOA, Microservices, ETL or other integration technologies.
• 5+ years of experience with working content or knowledge management systems, search engines, relational databases, NoSQL databases, ETL tools, geospatial systems, or semantic technology.
• 3+ years of hands-on experience with a MarkLogic framework, DynamoDB preferred.
• 3+ years of hands-on experience with AWS services ( S3, Kinesis, Lambda, Athena, Glue, EMR) required.
• 3+ years of analytics tools like SAS, R, Python, and other advanced statistical software.
• 3+ years of Web development experience with Angular, JavaScript, and Node.js.
• Experience with JSON or XML data modeling required.
• Experience with Git/GitHub, branching, and other modern source code management methodologies required.
• Domain knowledge of NoSQL or relational database required.
• Understanding of database architecture and performance implications required.
• Experience with Machine Learning and Artificial Intelligence.
• Ability to multi-task effectively.
• Ability to work collaboratively as part of an Agile Team.
• Extensive knowledge and experience with Python, JavaScript and Java.
• Excellent written and verbal communication skills, sense of ownership, urgency and drive.
We look forward to reviewing your application. We encourage everyone to apply - even if every box isn’t checked for what you are looking for or what is required.
PDSINC, LLC is an Equal Opportunity Employer.
Compensation:
Their role is to develop, enhance and support data pipelines using Informatica Power center, AWS and Snowflake.
PROJECT INFORMATION:
Contractor will be working on the Modernizers team, EAM BI team. Their role is to develop, enhance and support data pipelines using Informatica Power center, AWS and Snowflake.
PRINCIPAL RESPONSIBILITIES:
• Designs and develops code and data pipelines to ingest from relational databases (Oracle, SQL Server, DB2, Aurora), file shares, and web services.
• Design and build Informatica Power Center mappings and workflows
• Streaming ingestion with Kinesis Streams, Kinesis Firehose, Kinesis Analytics and Kafka (MSK)
• Build Data Lake on AWS S3 with optimal performance considerations by partitioning and compressing data.
• Data Engineering and Analytics using AWS Glue, Informatica, EMR, Spark, Athena, Python.
• Data modeling and building Data Warehouse using Snowflake.
• Designs and develops code and data pipelines to ingest relational databases, file shares, and web services.
• Designs JavaScript modules and REST APIs utilizing MarkLogic to support complex searches.
• Develops MarkLogic integrations with existing enterprise platforms.
• Participates in requirements definition, system architecture design, and data architecture design.
• Participates in all aspects of the software life cycle using Agile development methodologies.
• Build and design Informatica Power Center mappings and workflows
MINIMUM QUALIFICATIONS:
• Bachelor’s degree in Computer Science, Computer Information Systems, Engineering, Statistics or closely related field (willing to accept foreign education equivalent) (required).
• Experience in AWS services for data and analytics (required).
• 5 years of experience in Data Ingestion, Data Extraction, and Data Integration (required).
PREFERRED QUALIFICATIONS:
• 5+ years of experience in Enterprise Information Solution Architecture, Design, and development required.
• 5+ years of experience with integration architectures such as SOA, Microservices, ETL or other integration technologies.
• 5+ years of experience with working content or knowledge management systems, search engines, relational databases, NoSQL databases, ETL tools, geospatial systems, or semantic technology.
• 3+ years of hands-on experience with a MarkLogic framework, DynamoDB preferred.
• 3+ years of hands-on experience with AWS services ( S3, Kinesis, Lambda, Athena, Glue, EMR) required.
• 3+ years of analytics tools like SAS, R, Python, and other advanced statistical software.
• 3+ years of Web development experience with Angular, JavaScript, and Node.js.
• Experience with JSON or XML data modeling required.
• Experience with Git/GitHub, branching, and other modern source code management methodologies required.
• Domain knowledge of NoSQL or relational database required.
• Understanding of database architecture and performance implications required.
• Experience with Machine Learning and Artificial Intelligence.
• Ability to multi-task effectively.
• Ability to work collaboratively as part of an Agile Team.
• Extensive knowledge and experience with Python, JavaScript and Java.
• Excellent written and verbal communication skills, sense of ownership, urgency and drive.
We look forward to reviewing your application. We encourage everyone to apply - even if every box isn’t checked for what you are looking for or what is required.
PDSINC, LLC is an Equal Opportunity Employer.
Share This Job:
Related Jobs:
Login to save this search and get notified of similar positions.About Phoenix, AZ
Ready to elevate your career in the vibrant Phoenix, Arizona area? Explore our diverse job opportunities in this dynamic region known for its sunny skies, breathtaking desert landscapes, and thriving job market. Known as the Valley of the Sun, Phoenix boasts a unique mix of Southwestern charm and urban sophistication. Discover the bustling arts scene at the Phoenix Art Museum, catch a performance at the iconic Orpheum Theatre, or cheer on the Arizona Diamondbacks at Chase Field. With an array of outdoor activities in stunning parks like Camelback Mountain and Papago Park, plus delectable Southwestern cuisine to savor, there's no shortage of reasons to make Phoenix your professional playground. Browse our job listings today and unlock a world of career possibilities in this exciting region!